import xlwings as xw 
# 应用
app = xw.App(add_book=False)
# 创建工作簿
wb = app.books.add()

# 创建工作表
sht = wb.sheets['sss']

# 写入单元格
sht.range('a1').value="fxxx"
sht.range('c4').value = [1,2,3,4]

# 保存
wb.save('demo.xlsx')

# 打开工作簿
wb = xw.books.open("demo.xlsx")

# 读取单元格
cell_val = sht.range("a1:c4").value
print(cell_val)
# 退出
app.quit()
wb.close() 


